﻿#region Copyright (c) 2006-2012 nHydrate.org, All Rights Reserved
// --------------------------------------------------------------------- *
//                           NHYDRATE.ORG                                *
//              Copyright (c) 2006-2012 All Rights reserved              *
//                                                                       *
//                                                                       *
// This file and its contents are protected by United States and         *
// International copyright laws.  Unauthorized reproduction and/or       *
// distribution of all or any portion of the code contained herein       *
// is strictly prohibited and will result in severe civil and criminal   *
// penalties.  Any violations of this copyright will be prosecuted       *
// to the fullest extent possible under law.                             *
//                                                                       *
// THE SOURCE CODE CONTAINED HEREIN AND IN RELATED FILES IS PROVIDED     *
// TO THE REGISTERED DEVELOPER FOR THE PURPOSES OF EDUCATION AND         *
// TROUBLESHOOTING. UNDER NO CIRCUMSTANCES MAY ANY PORTION OF THE SOURCE *
// CODE BE DISTRIBUTED, DISCLOSED OR OTHERWISE MADE AVAILABLE TO ANY     *
// THIRD PARTY WITHOUT THE EXPRESS WRITTEN CONSENT OF THE NHYDRATE GROUP *
//                                                                       *
// UNDER NO CIRCUMSTANCES MAY THE SOURCE CODE BE USED IN WHOLE OR IN     *
// PART, AS THE BASIS FOR CREATING A PRODUCT THAT PROVIDES THE SAME, OR  *
// SUBSTANTIALLY THE SAME, FUNCTIONALITY AS THIS PRODUCT                 *
//                                                                       *
// THE REGISTERED DEVELOPER ACKNOWLEDGES THAT THIS SOURCE CODE           *
// CONTAINS VALUABLE AND PROPRIETARY TRADE SECRETS OF NHYDRATE,          *
// THE REGISTERED DEVELOPER AGREES TO EXPEND EVERY EFFORT TO             *
// INSURE ITS CONFIDENTIALITY.                                           *
//                                                                       *
// THE END USER LICENSE AGREEMENT (EULA) ACCOMPANYING THE PRODUCT        *
// PERMITS THE REGISTERED DEVELOPER TO REDISTRIBUTE THE PRODUCT IN       *
// EXECUTABLE FORM ONLY IN SUPPORT OF APPLICATIONS WRITTEN USING         *
// THE PRODUCT.  IT DOES NOT PROVIDE ANY RIGHTS REGARDING THE            *
// SOURCE CODE CONTAINED HEREIN.                                         *
//                                                                       *
// THIS COPYRIGHT NOTICE MAY NOT BE REMOVED FROM THIS FILE.              *
// --------------------------------------------------------------------- *
#endregion
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.VisualStudio.Modeling.Validation;

namespace nHydrate.Dsl
{
	[ValidationState(ValidationState.Enabled)]
	partial class Field
	{
		#region Dirty
		[System.ComponentModel.Browsable(false)]
		internal bool IsDirty
		{
			get { return _isDirty; }
			set { _isDirty = value; }
		}
		private bool _isDirty = false;

		protected override void OnPropertyChanged(System.ComponentModel.PropertyChangedEventArgs e)
		{
			this.IsDirty = true;
			base.OnPropertyChanged(e);
		}
		#endregion

		[ValidationMethod(ValidationCategories.Open | ValidationCategories.Save | ValidationCategories.Menu | ValidationCategories.Custom | ValidationCategories.Load)]
		public void Validate(ValidationContext context)
		{
			var timer = nHydrate.Dsl.Custom.DebugHelper.StartTimer();
			try
			{
				if (!this.IsGenerated) return;
				//if (!this.IsDirty) return;

				#region Check valid name
				if (!ValidationHelper.ValidDatabaseIdenitifer(this.DatabaseName))
					context.LogError(string.Format(ValidationHelper.ErrorTextInvalidIdentifier, this.Entity.Name + "." + this.Name), string.Empty, this);
				else if (!ValidationHelper.ValidCodeIdentifier(this.PascalName))
					context.LogError(string.Format(ValidationHelper.ErrorTextInvalidIdentifier, this.Entity.Name + "." + this.Name), string.Empty, this);
				else if (!ValidationHelper.ValidFieldIdentifier(this.PascalName))
					context.LogError(string.Format(ValidationHelper.ErrorTextInvalidIdentifier, this.Entity.Name + "." + this.Name), string.Empty, this);

				#endregion

				#region Check valid name based on codefacade
				if ((!string.IsNullOrEmpty(this.CodeFacade)) && !ValidationHelper.ValidDatabaseIdenitifer(this.CodeFacade))
					context.LogError(ValidationHelper.ErrorTextInvalidCodeFacade, string.Empty, this);

				if (this.IsNumericType())
				{
					if (!double.IsNaN(this.Min) && (!double.IsNaN(this.Max)))
					{
						if (this.Min > this.Max)
							context.LogError(ValidationHelper.ErrorTextMinMaxValueMismatch, string.Empty, this);
					}
				}
				else //Non-numeric
				{
					//Neither should be set
					if (!double.IsNaN(this.Min) || (!double.IsNaN(this.Max)))
					{
						context.LogError(ValidationHelper.ErrorTextMinMaxValueInvalidType, string.Empty, this);
					}
				}
				#endregion

				#region Validate identity field
				if (this.Identity != IdentityTypeConstants.None && !this.DataType.SupportsIdentity())
				{
					context.LogError(string.Format(ValidationHelper.ErrorTextInvalidIdentityColumn, this.Name), string.Empty, this);
				}
				#endregion

				#region Varchar Max only supported in SQL 2008

				//if (((ModelRoot)this.Root).SQLServerType == SQLServerTypeConstants.SQL2005)
				//{
				//  if (ModelHelper.SupportsMax(this.DataType) && this.Length == 0)
				//  {
				//    context.LogError(string.Format(ValidationHelper.ErrorTextColumnMaxNotSupported, this.Name), string.Empty, this);
				//  }
				//}

				#endregion

				#region Columns cannot be 0 length

				if (!this.DataType.SupportsMax() && this.Length == 0)
				{
					context.LogError(string.Format(ValidationHelper.ErrorTextColumnLengthNotZero, this.Name), string.Empty, this);
				}

				#endregion

				#region Validate Decimals

				if (this.DataType == DataTypeConstants.Decimal)
				{
					if (this.Length < 1 || this.Length > 38)
						context.LogError(string.Format(ValidationHelper.ErrorTextColumnDecimalPrecision, this.Name), string.Empty, this);
					if (this.Scale < 0 || this.Scale > this.Length)
						context.LogError(string.Format(ValidationHelper.ErrorTextColumnDecimalScale, this.Name), string.Empty, this);
				}

				#endregion

				#region Validate max lengths

				var validatedLength = this.DataType.ValidateDataTypeMax(this.Length);
				if (validatedLength != this.Length)
				{
					context.LogError(string.Format(ValidationHelper.ErrorTextColumnMaxLengthViolation, this.Entity.Name + "." + this.Name, validatedLength, this.DataType.ToString()), string.Empty, this);
				}

				#endregion

				#region Verify Datatypes for SQL 2005/2008

				if ((this.Entity.nHydrateModel.SupportedPlatforms & DatabasePlatformConstants.SQLServer) == DatabasePlatformConstants.SQLServer)
				{
					if (!this.DataType.IsSupportedType(this.Entity.nHydrateModel.SQLServerType))
					{
						context.LogError(string.Format(ValidationHelper.ErrorTextDataTypeNotSupported, this.Name), string.Empty, this);
					}
				}

				#endregion

				#region Computed Column

				if (this.IsCalculated)
				{
					if (this.Formula.Trim() == "")
					{
						context.LogError(string.Format(ValidationHelper.ErrorTextComputeColumnNoFormula, this.Name), string.Empty, this);
					}

					if (this.IsPrimaryKey)
					{
						context.LogError(string.Format(ValidationHelper.ErrorTextComputeColumnNoPK, this.Name), string.Empty, this);
					}

				}

				if (!this.IsCalculated && !string.IsNullOrEmpty(this.Formula))
				{
					context.LogError(string.Format(ValidationHelper.ErrorTextComputeNonColumnHaveFormula, this.Name), string.Empty, this);
				}

				#endregion

				#region Validate Defaults

				if (!string.IsNullOrEmpty(this.Default))
				{
					if ((this.Entity.nHydrateModel.SupportedPlatforms | DatabasePlatformConstants.SQLServer) == DatabasePlatformConstants.SQLServer 
						&& !this.CanHaveDefault())
					{
						context.LogError(string.Format(ValidationHelper.ErrorTextColumnCannotHaveDefault, this.Name), string.Empty, this);
					}
					else if (!this.IsValidDefault())
					{
						context.LogWarning(string.Format(ValidationHelper.ErrorTextColumnInvalidDefault, this.Name), string.Empty, this);
					}
				}

				#endregion

				#region Check Decimals for common error

				if (this.DataType == DataTypeConstants.Decimal)
				{
					if (this.Length == 1)
						context.LogError(string.Format(ValidationHelper.ErrorTextDecimalColumnTooSmall, this.Name, this.Length.ToString()), string.Empty, this);
				}

				#endregion

				#region Verify Metadata

				var metaKeyList = new List<string>();
				foreach (var item in this.FieldMetadata)
				{
					if (string.IsNullOrEmpty(item.Key) || metaKeyList.Contains(item.Key.ToLower()))
					{
						context.LogError(ValidationHelper.ErrorTextMetadataInvalid, string.Empty, this);
					}
					else
					{
						metaKeyList.Add(item.Key.ToString());
					}
				}

				#endregion

				#region Identity Columns cannot have defaults

				if (this.Identity != IdentityTypeConstants.None && !string.IsNullOrEmpty(this.Default))
				{
					context.LogError(string.Format(ValidationHelper.ErrorTextColumnIdentityHasDefault, this.Entity.Name + "." + this.Name), string.Empty, this);
				}

				#endregion

				#region Non-nullable, ReadOnly propeties must have a default (except identities)
				if (this.IsReadOnly && !this.Nullable && (this.Identity != IdentityTypeConstants.Database) && string.IsNullOrEmpty(this.Default))
				{
					context.LogError(string.Format(ValidationHelper.ErrorTextColumnReadonlyNeedsDefault, this.Entity.Name + "." + this.Name), string.Empty, this);
				}
				#endregion

				#region Verify Entity is in some module
				if (this.Entity.nHydrateModel.UseModules && (this.Modules.Count == 0) && this.IsGenerated)
				{
					context.LogError(string.Format(ValidationHelper.ErrorTextObjectNotInModule, this.Entity.Name + "." + this.Name), string.Empty, this);
				}
				#endregion

				#region MySQL
				if ((this.Entity.nHydrateModel.SupportedPlatforms & DatabasePlatformConstants.MySQL) == DatabasePlatformConstants.MySQL)
				{
					if (!ValidationHelper.MySQLSupportedDatatype(this.DataType))
					{
						context.LogError(string.Format(ValidationHelper.ErrorTextMySQLDatatypeField, this.DataType.ToString(), this.Entity.Name + "." + this.Name), string.Empty, this);
					}

					if (this.IsCalculated)
					{
						context.LogError(string.Format(ValidationHelper.ErrorTextMySQLCalculated, this.Entity.Name + "." + this.Name), string.Empty, this);
					}

					//There is no varchar max
					if (this.DataType.SupportsMax() && this.Length == 0)
					{
						context.LogError(string.Format(ValidationHelper.ErrorTextMySQLNoMaxLength, this.Entity.Name + "." + this.Name), string.Empty, this);
					}

				}
				#endregion

			}
			catch (Exception ex)
			{
				throw;
			}
			finally
			{
				nHydrate.Dsl.Custom.DebugHelper.StopTimer(timer, "Field Validate - Fields");
			}
		}

	}
}
